Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_AW_LOAD_DIMENSIONS

`ALL_AW_LOAD_DIMENSIONS` lists the load specifications for dimensions.

Dimension load specifications are created by the `DBMS_AWM.CREATE_AWDIMLOAD_SPEC` procedure.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`owner` | `varchar2(30)` |  | Owner of the source dimension in the OLAP Catalog.
`dimension_name` | `varchar2(30)` |  | Name of the source dimension in the OLAP Catalog.
`load_name` | `varchar2(60)` |  | Name of the load specification.
`load_type` | `varchar2(60)` |  | '`FULL_LOAD_ADDITIONS_ONLY`' -- Only new dimension members will be loaded when the dimension is refreshed. (Default) '`FULL_LOAD`' -- When the dimension is refreshed, all dimension members in the workspace will be deleted, then all the members of the source dimension will be loaded.